﻿use sms
go
if exists(select name from sysobjects where name ='cp_mark_resend' and type = 'P')
drop procedure cp_mark_resend
go  
--重发
create procedure cp_mark_resend
@id int
as
update [Message] set [State] = 0 where ID = @id
go